<?php
/**
 *   Kaltura Browser - components/com_kaltura/helpers/externaldatabase.php
 *   Author: Juan Dapena Paz (juan@bittingbits.com)
 *   Copyright (C) 2011 Bitting Bits S.L.
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
defined('_JEXEC') or die('Restricted access');

class ExternalDatabase {
    public static function getDatabaseInstance($instance_id)
    {
        $db = JFactory::getDBO();
    
        $query = 'SELECT * FROM #__Kaltura_instances WHERE id='.$instance_id;
        
        $db->setQuery($query);
        $database_data = $db->loadObject();
        
        $option = array();
        
        $option['driver']   = 'mysql';
        $option['host']     = $database_data->dbhost;
        $option['user']     = $database_data->dbuser;
        $option['password'] = $database_data->dbpasswd;
        $option['database'] = 'kaltura';
        $option['prefix'] = '';
        
        $cdb =& JDatabase::getInstance($option);
        return $cdb;
    }
}
?>
